CREATE TABLE [dbo].[Exhb_Setup]
(
[MEET_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BOOTH_SCALE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BOOTH_LEN] [int] NOT NULL CONSTRAINT [DF_Exhb_Setup_BOOTH_LEN] DEFAULT ((0)),
[BOOTH_WIDTH] [int] NOT NULL CONSTRAINT [DF_Exhb_Setup_BOOTH_WIDTH] DEFAULT ((0)),
[REG_CITY_ST] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_REG_CITY_ST] DEFAULT ((0)),
[REG_BADGE] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_REG_BADGE] DEFAULT ((0)),
[REG_COUNTRY] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_REG_COUNTRY] DEFAULT ((0)),
[REG_FNAME] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_REG_FNAME] DEFAULT ((0)),
[REG_TRACK] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_REG_TRACK] DEFAULT ((0)),
[CONTACT_WIN] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_CONTACT_WIN] DEFAULT ((0)),
[HIST_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VALIDATE_PREF_BOOTHS] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_VALIDATE_PREF_BOOTHS] DEFAULT ((0)),
[HIST_NBR] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_HIST_NBR] DEFAULT ((0)),
[HIST_DIM] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_HIST_DIM] DEFAULT ((0)),
[HIST_UNIT] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_HIST_UNIT] DEFAULT ((0)),
[FREE_PASS] [int] NOT NULL CONSTRAINT [DF_Exhb_Setup_FREE_PASS] DEFAULT ((0)),
[ABOVE_ALLOT] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Exhb_Setup_ABOVE_ALLOT] DEFAULT ((0)),
[GST_AMT] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Exhb_Setup_GST_AMT] DEFAULT ((0)),
[MEETING] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Exhb_Setup_MEETING] DEFAULT (''),
[PROSP_ADD] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_PROSP_ADD] DEFAULT ((0)),
[PROSP_SECURE] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_PROSP_SECURE] DEFAULT ((0)),
[DOWN_PCTG] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Exhb_Setup_DOWN_PCTG] DEFAULT ((0)),
[NBR_PAYMENTS] [int] NOT NULL CONSTRAINT [DF_Exhb_Setup_NBR_PAYMENTS] DEFAULT ((0)),
[PYMT1_DATE] [datetime] NULL,
[PYMT2_DATE] [datetime] NULL,
[PYMT3_DATE] [datetime] NULL,
[PYMT4_DATE] [datetime] NULL,
[PYMT5_DATE] [datetime] NULL,
[PYMT6_DATE] [datetime] NULL,
[PROD_CONFLICTS] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_PROD_CONFLICTS] DEFAULT ((0)),
[COMP_CONFLICTS] [bit] NOT NULL CONSTRAINT [DF_Exhb_Setup_COMP_CONFLICTS] DEFAULT ((0)),
[MAX_FREE_PASSES] [int] NOT NULL CONSTRAINT [DF_Exhb_Setup_MAX_FREE_PASSES] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE CLUSTERED INDEX [iExhb_SetupID] ON [dbo].[Exhb_Setup] ([MEET_ID]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Exhb_Setup] TO [IMIS]
GRANT SELECT ON  [dbo].[Exhb_Setup] TO [IMIS]
GRANT INSERT ON  [dbo].[Exhb_Setup] TO [IMIS]
GRANT DELETE ON  [dbo].[Exhb_Setup] TO [IMIS]
GRANT UPDATE ON  [dbo].[Exhb_Setup] TO [IMIS]
GO